{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "cefb7276",
   "metadata": {},
   "source": [
    "# jupyter notebook 扩展"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "364d38bc",
   "metadata": {},
   "source": [
    "* 首先，安装 jupyter notebook 插件前，需先完成一下两步：\n",
    "\n",
    "1. 安装并激活 jupyter_contrib_nbextensions，\n",
    "为了快速安装的速度，先临时使用清华的镜像，这样并不会改变默认的pip参数。\n",
    "* pip install -i https://pypi.tuna.tsinghua.edu.cn/simple flask\n",
    "* pip install jupyter_contrib_nbextensions \n",
    "* jupyter contrib nbextension install --user\n",
    "2. 安装并启用 Jupyter Nbextensions Configurator\n",
    "\n",
    "* pip install jupyter_nbextensions_configurator\n",
    "* jupyter nbextensions_configurator enable --user\n",
    "3. 除了实用 pip 安装以外，还可以使用conda进行完成以上两步，命令如下：\n",
    "\n",
    "* conda install -c conda-forge jupyter_contrib_nbextensionsconda install -c\n",
    "* conda-forge jupyter_nbextensions_configurator\n",
    "* 安装完成以后，打开 jupyter notebook 可以看到菜单栏多了 ：Nbextensions 一栏，这样就可以安装插件了，推荐三个常用的插件：Table of Contents， Variable Inspector 和 ExcecuteTime。"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "965b6a55",
   "metadata": {},
   "source": [
    "# 初识地图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ca2cfb67",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "77303e5e",
   "metadata": {},
   "source": [
    "# Web服务API简介"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "25d51355",
   "metadata": {},
   "source": [
    "## 地理/逆地理编码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4c5a6cd1",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:00:50.983945Z",
     "start_time": "2022-04-18T12:00:50.554166Z"
    }
   },
   "outputs": [],
   "source": [
    "# 1.调用requests模块（google chrome 浏览器）\n",
    "import requests\n",
    "# 2.请求方法：GET\n",
    "# 3.URL地址：https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "# 4.准备参数，用于交换数据 payload\n",
    "payload = {\n",
    "    \"key\": \"ce765ab7259251e661b558e79afbe494\",\n",
    "    \"address\": \"广东省广州市从化区\"\n",
    "}\n",
    "# 5.发起请求\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "ed4b4c15",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:00:54.774444Z",
     "start_time": "2022-04-18T12:00:54.759442Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7ad3dbcd",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:01:02.773690Z",
     "start_time": "2022-04-18T12:01:02.753026Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.586605,23.548852',\n",
       "   'level': '区县'}]}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "78486973",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:13:05.738292Z",
     "start_time": "2022-04-18T12:13:05.717551Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.586605,23.548852'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州南方学院_location = r.json()['geocodes'][0]['location']\n",
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51761fc3",
   "metadata": {},
   "source": [
    "## 逆地理编码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "833cae69",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:39:12.227150Z",
     "start_time": "2022-04-18T12:39:11.936570Z"
    }
   },
   "outputs": [],
   "source": [
    "# extensions = all\n",
    "import requests\n",
    "\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\": \"ce765ab7259251e661b558e79afbe494\",\n",
    "    \"address\": \"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "\n",
    "r = requests.get(url=regeo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "d3b618d4",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:39:12.327182Z",
     "start_time": "2022-04-18T12:39:12.315349Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "c550770a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:39:12.698427Z",
     "start_time": "2022-04-18T12:39:12.680411Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区温泉镇中心大学南方学院',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.678280,23.628439',\n",
       "   'level': '兴趣点'}]}"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "ce2509e4",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:42:41.891426Z",
     "start_time": "2022-04-18T12:42:41.698176Z"
    }
   },
   "outputs": [],
   "source": [
    "# extension = all\n",
    "import requests\n",
    "\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\": \"ce765ab7259251e661b558e79afbe494\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"true\",\n",
    "}\n",
    "\n",
    "r = requests.get(url=regeo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "335f10d7",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:42:42.566676Z",
     "start_time": "2022-04-18T12:42:42.548399Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "533870bd",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:42:43.193992Z",
     "start_time": "2022-04-18T12:42:43.175465Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区街口街道中心会堂',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '街口街道',\n",
       "   'towncode': '440117001000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '新城东路',\n",
       "    'number': '99号',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686'},\n",
       "   'businessAreas': [{'location': '113.586019,23.546975',\n",
       "     'name': '街口',\n",
       "     'id': '440117'},\n",
       "    {'location': '113.568684,23.563922', 'name': '城郊', 'id': '440117'},\n",
       "    {'location': '113.604074,23.533964', 'name': '江埔', 'id': '440117'}]},\n",
       "  'pois': [{'id': 'B00140MR5X',\n",
       "    'name': '中国银行(广州从化支行)',\n",
       "    'type': '金融保险服务;银行;中国银行',\n",
       "    'tel': '020-87929678;020-87923974',\n",
       "    'direction': '南',\n",
       "    'distance': '103.541',\n",
       "    'location': '113.586937,23.547972',\n",
       "    'address': '街口镇新城东路74号',\n",
       "    'poiweight': '0.374805',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24FS',\n",
       "    'name': '从化区人大常委会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87926111',\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '街口街道新城东路99号大院内',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24FT',\n",
       "    'name': '从化区政协',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922613',\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0014072CF',\n",
       "    'name': '广州市从化区人民政府',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87928410;020-87922712',\n",
       "    'direction': '南',\n",
       "    'distance': '66.6705',\n",
       "    'location': '113.586405,23.548281',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.529579',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141PSGY',\n",
       "    'name': '从化区委组织部',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922092',\n",
       "    'direction': '西南',\n",
       "    'distance': '0.66843',\n",
       "    'location': '113.586600,23.548848',\n",
       "    'address': '街口街新城东路99号',\n",
       "    'poiweight': '0.245493',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141PSC0',\n",
       "    'name': '从化区委宣传部',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922221',\n",
       "    'direction': '西南',\n",
       "    'distance': '0.66843',\n",
       "    'location': '113.586600,23.548848',\n",
       "    'address': '街口街新城东路99号',\n",
       "    'poiweight': '0.249396',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24ZR',\n",
       "    'name': '中共广州市从化区委员会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140ICZY',\n",
       "    'name': '中心会堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '0.532943',\n",
       "    'location': '113.586608,23.548848',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.276118',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140V14Y',\n",
       "    'name': '国美电器(从化店)',\n",
       "    'type': '购物服务;家电电子卖场;国美',\n",
       "    'tel': '020-37939789',\n",
       "    'direction': '东',\n",
       "    'distance': '129.768',\n",
       "    'location': '113.587771,23.548384',\n",
       "    'address': '街口街荔香村1期1-3栋2层',\n",
       "    'poiweight': '0.287666',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MJ8Z',\n",
       "    'name': '苏宁易购(从化街口路店)',\n",
       "    'type': '购物服务;家电电子卖场;苏宁',\n",
       "    'tel': '19902230595',\n",
       "    'direction': '西南',\n",
       "    'distance': '145.411',\n",
       "    'location': '113.585729,23.547820',\n",
       "    'address': '新城东路80号一、二层',\n",
       "    'poiweight': '0.514928',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG7J09R',\n",
       "    'name': '从化区综治信访维稳中心',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87928733',\n",
       "    'direction': '东南',\n",
       "    'distance': '84.9475',\n",
       "    'location': '113.587181,23.548300',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.169373',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UQW3',\n",
       "    'name': '明师教育从化新世纪上课点',\n",
       "    'type': '科教文化服务;培训机构;培训机构',\n",
       "    'tel': '020-87957748',\n",
       "    'direction': '东南',\n",
       "    'distance': '135.505',\n",
       "    'location': '113.587312,23.547820',\n",
       "    'address': '街口镇新城东路68-1号(肯德基对面)',\n",
       "    'poiweight': '0.140757',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24CK',\n",
       "    'name': '广州市从化区国防动员委员会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UNTN',\n",
       "    'name': '东科商务·富逸财富港',\n",
       "    'type': '商务住宅;楼宇;商务写字楼',\n",
       "    'tel': '13725145988',\n",
       "    'direction': '西南',\n",
       "    'distance': '182.033',\n",
       "    'location': '113.585527,23.547547',\n",
       "    'address': '新城东路80-12',\n",
       "    'poiweight': '0.26943',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140UGAP',\n",
       "    'name': '林苑大厦(新城东路)',\n",
       "    'type': '商务住宅;楼宇;商务写字楼',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '188.329',\n",
       "    'location': '113.587891,23.547636',\n",
       "    'address': '新城东路68号',\n",
       "    'poiweight': '0.344929',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UW5K',\n",
       "    'name': '从化区创建平安工作领导小组办公室',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '106.187',\n",
       "    'location': '113.585646,23.548479',\n",
       "    'address': '新城中路7-9号附近',\n",
       "    'poiweight': '0.170039',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140J9N4',\n",
       "    'name': '从化区文化市场综合行政执法队',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '148.352',\n",
       "    'location': '113.585177,23.549109',\n",
       "    'address': '新城中路39',\n",
       "    'poiweight': '0.141105',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MIC9',\n",
       "    'name': '从化商业幼儿园',\n",
       "    'type': '科教文化服务;学校;幼儿园',\n",
       "    'tel': '020-87922390',\n",
       "    'direction': '北',\n",
       "    'distance': '189.626',\n",
       "    'location': '113.586572,23.550557',\n",
       "    'address': '西宁中路',\n",
       "    'poiweight': '0.205589',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NPDY',\n",
       "    'name': '新村居委会社区退休职工管理服务站',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '171.308',\n",
       "    'location': '113.586213,23.550350',\n",
       "    'address': '西宁中路148号之3附近',\n",
       "    'poiweight': '0.123706',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NETK',\n",
       "    'name': '新村社区居委会(西宁中路五巷)',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': '020-87935109',\n",
       "    'direction': '西北',\n",
       "    'distance': '189.905',\n",
       "    'location': '113.585741,23.550365',\n",
       "    'address': '新村东路61-1',\n",
       "    'poiweight': '0.404627',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NTQ0',\n",
       "    'name': '中共新村社区支部委员会(西宁中路五巷)',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '189.905',\n",
       "    'location': '113.585741,23.550365',\n",
       "    'address': '新村路60号',\n",
       "    'poiweight': '0.134518',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141ID88',\n",
       "    'name': '富逸华庭',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '西南',\n",
       "    'distance': '142.175',\n",
       "    'location': '113.586068,23.547672',\n",
       "    'address': '新城东路80号',\n",
       "    'poiweight': '0.348063',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141RB6B',\n",
       "    'name': '东华里',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '179.954',\n",
       "    'location': '113.584868,23.548563',\n",
       "    'address': '新城中路10号',\n",
       "    'poiweight': '0.367551',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF32RLG',\n",
       "    'name': '从化区人事局',\n",
       "    'type': '政府机构及社会团体;政府机关;政府机关相关',\n",
       "    'tel': '020-87922814',\n",
       "    'direction': '南',\n",
       "    'distance': '59.3667',\n",
       "    'location': '113.586410,23.548349',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.11745',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF2N8SM',\n",
       "    'name': '从化区监察局',\n",
       "    'type': '政府机构及社会团体;政府机关;政府机关相关',\n",
       "    'tel': [],\n",
       "    'direction': '西南',\n",
       "    'distance': '72.9685',\n",
       "    'location': '113.586272,23.548271',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.11745',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B001408643',\n",
       "    'name': '从化区人民政府招待所',\n",
       "    'type': '住宿服务;旅馆招待所;旅馆招待所',\n",
       "    'tel': '020-87922022',\n",
       "    'direction': '东',\n",
       "    'distance': '108.333',\n",
       "    'location': '113.587615,23.549155',\n",
       "    'address': '街口街西宁横街75号',\n",
       "    'poiweight': '0.360069',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140TWK0',\n",
       "    'name': '肯德基甜品站(新世纪店)',\n",
       "    'type': '餐饮服务;快餐厅;肯德基',\n",
       "    'tel': '020-87939871;020-87939891',\n",
       "    'direction': '东南',\n",
       "    'distance': '180.896',\n",
       "    'location': '113.587847,23.547690',\n",
       "    'address': '新城东路66号林苑大厦1-2层',\n",
       "    'poiweight': '0.355148',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0H6DUBGQ5',\n",
       "    'name': '城悦旅馆',\n",
       "    'type': '住宿服务;旅馆招待所;旅馆招待所',\n",
       "    'tel': '020-87930209;13798058272',\n",
       "    'direction': '西',\n",
       "    'distance': '183.527',\n",
       "    'location': '113.584900,23.549382',\n",
       "    'address': '新城中路41号(广播电视器材站旁)',\n",
       "    'poiweight': '0.27959',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141KB1H',\n",
       "    'name': '秋田菊寿司料理',\n",
       "    'type': '餐饮服务;外国餐厅;日本料理',\n",
       "    'tel': '13602412074',\n",
       "    'direction': '东南',\n",
       "    'distance': '111.003',\n",
       "    'location': '113.587545,23.548348',\n",
       "    'address': '街口街新城东路荔香村4栋104、107号',\n",
       "    'poiweight': '0.126091',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG6TUIH',\n",
       "    'name': '从化区广播电视台城区鳌头广播电视站工会委员会',\n",
       "    'type': '政府机构及社会团体;社会团体;社会团体相关',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '150.339',\n",
       "    'location': '113.585165,23.549144',\n",
       "    'address': '新城中路39',\n",
       "    'poiweight': '0.147889',\n",
       "    'businessarea': '街口'}],\n",
       "  'roads': [{'id': '020F49F0060454023',\n",
       "    'name': '新城东路',\n",
       "    'direction': '北',\n",
       "    'distance': '81.3964',\n",
       "    'location': '113.587,23.5481'},\n",
       "   {'id': '020F49F006045608841',\n",
       "    'name': '新城东路六巷',\n",
       "    'direction': '北',\n",
       "    'distance': '92.921',\n",
       "    'location': '113.587,23.548'},\n",
       "   {'id': '020F49F006045614615',\n",
       "    'name': '新城东七巷',\n",
       "    'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586,23.548'}],\n",
       "  'roadinters': [{'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586194,23.548025',\n",
       "    'first_id': '020F49F0060454023',\n",
       "    'first_name': '新城东路',\n",
       "    'second_id': '020F49F006045614615',\n",
       "    'second_name': '新城东七巷'}],\n",
       "  'aois': []}}"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "357fc0a9",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:42:44.597260Z",
     "start_time": "2022-04-18T12:42:44.579240Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "1bd4019e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:51:06.401708Z",
     "start_time": "2022-04-18T12:51:06.374700Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>tel</th>\n",
       "      <th>direction</th>\n",
       "      <th>distance</th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>poiweight</th>\n",
       "      <th>businessarea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B0FFG2JO93</td>\n",
       "      <td>柳州螺蛳粉(广百分店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>18177382828</td>\n",
       "      <td>东南</td>\n",
       "      <td>107.693</td>\n",
       "      <td>113.587515,23.548360</td>\n",
       "      <td>街口街道新城东路荔香村6号之三</td>\n",
       "      <td>0.192282</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B00141QWG4</td>\n",
       "      <td>兴旺奶茶店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>东</td>\n",
       "      <td>174.905</td>\n",
       "      <td>113.588198,23.549436</td>\n",
       "      <td>西宁中路西宁横街38</td>\n",
       "      <td>0.188565</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B0FFG6U8GM</td>\n",
       "      <td>柳州螺蛳粉(街口店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>18802032191</td>\n",
       "      <td>南</td>\n",
       "      <td>254.946</td>\n",
       "      <td>113.587138,23.546612</td>\n",
       "      <td>开源路22号</td>\n",
       "      <td>0.192843</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B0FFF3UVY1</td>\n",
       "      <td>乾坤小食坊</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13533280978</td>\n",
       "      <td>西北</td>\n",
       "      <td>223.634</td>\n",
       "      <td>113.584760,23.549940</td>\n",
       "      <td>街口街新村路125号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B0FFGF26NC</td>\n",
       "      <td>粤饺皇(西街店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13650952135;18689436339</td>\n",
       "      <td>东北</td>\n",
       "      <td>273.444</td>\n",
       "      <td>113.587903,23.551004</td>\n",
       "      <td>西宁中路85号</td>\n",
       "      <td>0.192125</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B0G17UXLBF</td>\n",
       "      <td>柳州螺蛳粉</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15920475898</td>\n",
       "      <td>东北</td>\n",
       "      <td>293.983</td>\n",
       "      <td>113.589121,23.550144</td>\n",
       "      <td>新城中路18号</td>\n",
       "      <td>0.214075</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B00140MHS7</td>\n",
       "      <td>荣记小食店(府前路店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>南</td>\n",
       "      <td>281.789</td>\n",
       "      <td>113.587545,23.546469</td>\n",
       "      <td>府前路35号</td>\n",
       "      <td>0.200038</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B00140I277</td>\n",
       "      <td>西宁面店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13926198181</td>\n",
       "      <td>东北</td>\n",
       "      <td>299.387</td>\n",
       "      <td>113.589241,23.550039</td>\n",
       "      <td>西宁中路24号</td>\n",
       "      <td>0.183469</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B0FFF3URIY</td>\n",
       "      <td>天天小食(城内路二巷)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15014242018</td>\n",
       "      <td>西南</td>\n",
       "      <td>306.382</td>\n",
       "      <td>113.583920,23.547614</td>\n",
       "      <td>城内路门口江路口</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B0FFF2N6NZ</td>\n",
       "      <td>雄旺宵夜</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13533392280;13544564117</td>\n",
       "      <td>西南</td>\n",
       "      <td>331.511</td>\n",
       "      <td>113.583911,23.547182</td>\n",
       "      <td>街口街城内路二巷2-3号首层</td>\n",
       "      <td>0.251673</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B0HBLUCPRK</td>\n",
       "      <td>庄记美食(城内路二巷)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13711560818</td>\n",
       "      <td>西南</td>\n",
       "      <td>337.368</td>\n",
       "      <td>113.583893,23.547113</td>\n",
       "      <td>街口街门口江</td>\n",
       "      <td>0.2165</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B0GK1ZXI1L</td>\n",
       "      <td>168肠粉皇(新村北路)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13533398028</td>\n",
       "      <td>西北</td>\n",
       "      <td>370.995</td>\n",
       "      <td>113.585246,23.551947</td>\n",
       "      <td>街口西宁西路25号(卓诗妮旁)</td>\n",
       "      <td>0.216536</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B0FFG8Q10H</td>\n",
       "      <td>527生活馆</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13535237634</td>\n",
       "      <td>南</td>\n",
       "      <td>366.316</td>\n",
       "      <td>113.587848,23.545761</td>\n",
       "      <td>府前路38号-204房</td>\n",
       "      <td>0.192282</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0FFH8B44L</td>\n",
       "      <td>坚记联兴牛腩粉(西宁店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅|生活服务;生活服务场所;生活服务场所</td>\n",
       "      <td>13168372713</td>\n",
       "      <td>东</td>\n",
       "      <td>406.69</td>\n",
       "      <td>113.590445,23.549844</td>\n",
       "      <td>西宁中路5号</td>\n",
       "      <td>0.144074</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B0FFF3V3XE</td>\n",
       "      <td>朝晖美食</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87900343</td>\n",
       "      <td>西北</td>\n",
       "      <td>400.835</td>\n",
       "      <td>113.583449,23.551002</td>\n",
       "      <td>龙江里13号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B00140I019</td>\n",
       "      <td>天记鹧鸪饭</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87937226</td>\n",
       "      <td>南</td>\n",
       "      <td>456.227</td>\n",
       "      <td>113.585455,23.544887</td>\n",
       "      <td>街口街青云路34号</td>\n",
       "      <td>0.189082</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B00140MFCB</td>\n",
       "      <td>联兴牛腩粉面(西宁西路二巷)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13556079936</td>\n",
       "      <td>西北</td>\n",
       "      <td>422.785</td>\n",
       "      <td>113.584364,23.552051</td>\n",
       "      <td>西宁西路70号</td>\n",
       "      <td>0.162561</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B0FFH8JTAB</td>\n",
       "      <td>海娃凉拌</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87926536;13538906708</td>\n",
       "      <td>南</td>\n",
       "      <td>430.844</td>\n",
       "      <td>113.587594,23.545085</td>\n",
       "      <td>府前路79号</td>\n",
       "      <td>0.192805</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B00140V9SO</td>\n",
       "      <td>四季清香美食店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13302396325</td>\n",
       "      <td>南</td>\n",
       "      <td>431.024</td>\n",
       "      <td>113.586347,23.544983</td>\n",
       "      <td>青云五巷街口街府前社区</td>\n",
       "      <td>0.193199</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B00141S0WM</td>\n",
       "      <td>时华煲仔饭店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13922138248</td>\n",
       "      <td>南</td>\n",
       "      <td>456.405</td>\n",
       "      <td>113.585317,23.544921</td>\n",
       "      <td>新城市场侧青云路4巷2号</td>\n",
       "      <td>0.222201</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B00141RB53</td>\n",
       "      <td>林记饮食店(街口村北)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13527808507</td>\n",
       "      <td>东</td>\n",
       "      <td>463.175</td>\n",
       "      <td>113.591105,23.548276</td>\n",
       "      <td>中华路一巷7号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B0GKXADTO1</td>\n",
       "      <td>文记美食(禤园东南)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15986347323</td>\n",
       "      <td>西北</td>\n",
       "      <td>477.628</td>\n",
       "      <td>113.584021,23.552435</td>\n",
       "      <td>新城中路雍晟美景家园西北侧约100米</td>\n",
       "      <td>0.216536</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B0FFGFWW37</td>\n",
       "      <td>风信子(街口店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13710622530</td>\n",
       "      <td>东南</td>\n",
       "      <td>491.088</td>\n",
       "      <td>113.588766,23.544905</td>\n",
       "      <td>街口街中蓝东路一巷8栋104号(即JJ俱乐部背后)</td>\n",
       "      <td>0.192058</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B0HRGK8EE5</td>\n",
       "      <td>豆花西施(成功路店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15917475948</td>\n",
       "      <td>东南</td>\n",
       "      <td>480.747</td>\n",
       "      <td>113.588470,23.544881</td>\n",
       "      <td>成功路51号</td>\n",
       "      <td>0.21612</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B00141RHCA</td>\n",
       "      <td>得米饭店(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-37939182</td>\n",
       "      <td>东</td>\n",
       "      <td>541.928</td>\n",
       "      <td>113.591625,23.547248</td>\n",
       "      <td>街口街河滨公园1号首层</td>\n",
       "      <td>0.172201</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B0FFG6VITP</td>\n",
       "      <td>第壹面(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13711276057</td>\n",
       "      <td>南</td>\n",
       "      <td>558.23</td>\n",
       "      <td>113.586630,23.543832</td>\n",
       "      <td>中田南路四巷1幢之四、之五</td>\n",
       "      <td>0.192771</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B0GR67ZOGW</td>\n",
       "      <td>通记美食</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15914298923;18998329882</td>\n",
       "      <td>西南</td>\n",
       "      <td>541.281</td>\n",
       "      <td>113.582557,23.545702</td>\n",
       "      <td>街口街蓝田西路85号</td>\n",
       "      <td>0.216561</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>B0FFF3UZMQ</td>\n",
       "      <td>满口香煲仔饭(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13016033133</td>\n",
       "      <td>东</td>\n",
       "      <td>574.716</td>\n",
       "      <td>113.591869,23.547001</td>\n",
       "      <td>东成路11号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>B00141RDMA</td>\n",
       "      <td>飘香美食店(中田东路店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13688899468</td>\n",
       "      <td>南</td>\n",
       "      <td>546.881</td>\n",
       "      <td>113.585497,23.544040</td>\n",
       "      <td>街口镇中田东路83号</td>\n",
       "      <td>0.222201</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>B0H6FZ31N4</td>\n",
       "      <td>养心园炖品</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87928037;15360080006</td>\n",
       "      <td>南</td>\n",
       "      <td>570.95</td>\n",
       "      <td>113.585687,23.543787</td>\n",
       "      <td>中田东路188号</td>\n",
       "      <td>0.216507</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id            name                             type  \\\n",
       "0   B0FFG2JO93     柳州螺蛳粉(广百分店)                     餐饮服务;中餐厅;中餐厅   \n",
       "1   B00141QWG4           兴旺奶茶店                     餐饮服务;中餐厅;中餐厅   \n",
       "2   B0FFG6U8GM      柳州螺蛳粉(街口店)                     餐饮服务;中餐厅;中餐厅   \n",
       "3   B0FFF3UVY1           乾坤小食坊                     餐饮服务;中餐厅;中餐厅   \n",
       "4   B0FFGF26NC        粤饺皇(西街店)                     餐饮服务;中餐厅;中餐厅   \n",
       "5   B0G17UXLBF           柳州螺蛳粉                     餐饮服务;中餐厅;中餐厅   \n",
       "6   B00140MHS7     荣记小食店(府前路店)                     餐饮服务;中餐厅;中餐厅   \n",
       "7   B00140I277            西宁面店                     餐饮服务;中餐厅;中餐厅   \n",
       "8   B0FFF3URIY     天天小食(城内路二巷)                     餐饮服务;中餐厅;中餐厅   \n",
       "9   B0FFF2N6NZ            雄旺宵夜                     餐饮服务;中餐厅;中餐厅   \n",
       "10  B0HBLUCPRK     庄记美食(城内路二巷)                     餐饮服务;中餐厅;中餐厅   \n",
       "11  B0GK1ZXI1L    168肠粉皇(新村北路)                     餐饮服务;中餐厅;中餐厅   \n",
       "12  B0FFG8Q10H          527生活馆                     餐饮服务;中餐厅;中餐厅   \n",
       "13  B0FFH8B44L    坚记联兴牛腩粉(西宁店)  餐饮服务;中餐厅;中餐厅|生活服务;生活服务场所;生活服务场所   \n",
       "14  B0FFF3V3XE            朝晖美食                     餐饮服务;中餐厅;中餐厅   \n",
       "15  B00140I019           天记鹧鸪饭                     餐饮服务;中餐厅;中餐厅   \n",
       "16  B00140MFCB  联兴牛腩粉面(西宁西路二巷)                     餐饮服务;中餐厅;中餐厅   \n",
       "17  B0FFH8JTAB            海娃凉拌                     餐饮服务;中餐厅;中餐厅   \n",
       "18  B00140V9SO         四季清香美食店                     餐饮服务;中餐厅;中餐厅   \n",
       "19  B00141S0WM          时华煲仔饭店                     餐饮服务;中餐厅;中餐厅   \n",
       "20  B00141RB53     林记饮食店(街口村北)                     餐饮服务;中餐厅;中餐厅   \n",
       "21  B0GKXADTO1      文记美食(禤园东南)                     餐饮服务;中餐厅;中餐厅   \n",
       "22  B0FFGFWW37        风信子(街口店)                     餐饮服务;中餐厅;中餐厅   \n",
       "23  B0HRGK8EE5      豆花西施(成功路店)                     餐饮服务;中餐厅;中餐厅   \n",
       "24  B00141RHCA       得米饭店(从化店)                     餐饮服务;中餐厅;中餐厅   \n",
       "25  B0FFG6VITP        第壹面(从化店)                     餐饮服务;中餐厅;中餐厅   \n",
       "26  B0GR67ZOGW            通记美食                     餐饮服务;中餐厅;中餐厅   \n",
       "27  B0FFF3UZMQ     满口香煲仔饭(从化店)                     餐饮服务;中餐厅;中餐厅   \n",
       "28  B00141RDMA    飘香美食店(中田东路店)                     餐饮服务;中餐厅;中餐厅   \n",
       "29  B0H6FZ31N4           养心园炖品                     餐饮服务;中餐厅;中餐厅   \n",
       "\n",
       "                         tel direction distance              location  \\\n",
       "0                18177382828        东南  107.693  113.587515,23.548360   \n",
       "1                         []         东  174.905  113.588198,23.549436   \n",
       "2                18802032191         南  254.946  113.587138,23.546612   \n",
       "3                13533280978        西北  223.634  113.584760,23.549940   \n",
       "4    13650952135;18689436339        东北  273.444  113.587903,23.551004   \n",
       "5                15920475898        东北  293.983  113.589121,23.550144   \n",
       "6                         []         南  281.789  113.587545,23.546469   \n",
       "7                13926198181        东北  299.387  113.589241,23.550039   \n",
       "8                15014242018        西南  306.382  113.583920,23.547614   \n",
       "9    13533392280;13544564117        西南  331.511  113.583911,23.547182   \n",
       "10               13711560818        西南  337.368  113.583893,23.547113   \n",
       "11               13533398028        西北  370.995  113.585246,23.551947   \n",
       "12               13535237634         南  366.316  113.587848,23.545761   \n",
       "13               13168372713         东   406.69  113.590445,23.549844   \n",
       "14              020-87900343        西北  400.835  113.583449,23.551002   \n",
       "15              020-87937226         南  456.227  113.585455,23.544887   \n",
       "16               13556079936        西北  422.785  113.584364,23.552051   \n",
       "17  020-87926536;13538906708         南  430.844  113.587594,23.545085   \n",
       "18               13302396325         南  431.024  113.586347,23.544983   \n",
       "19               13922138248         南  456.405  113.585317,23.544921   \n",
       "20               13527808507         东  463.175  113.591105,23.548276   \n",
       "21               15986347323        西北  477.628  113.584021,23.552435   \n",
       "22               13710622530        东南  491.088  113.588766,23.544905   \n",
       "23               15917475948        东南  480.747  113.588470,23.544881   \n",
       "24              020-37939182         东  541.928  113.591625,23.547248   \n",
       "25               13711276057         南   558.23  113.586630,23.543832   \n",
       "26   15914298923;18998329882        西南  541.281  113.582557,23.545702   \n",
       "27               13016033133         东  574.716  113.591869,23.547001   \n",
       "28               13688899468         南  546.881  113.585497,23.544040   \n",
       "29  020-87928037;15360080006         南   570.95  113.585687,23.543787   \n",
       "\n",
       "                      address poiweight businessarea  \n",
       "0             街口街道新城东路荔香村6号之三  0.192282           街口  \n",
       "1                  西宁中路西宁横街38  0.188565           街口  \n",
       "2                      开源路22号  0.192843           街口  \n",
       "3                  街口街新村路125号  0.192971           街口  \n",
       "4                     西宁中路85号  0.192125           街口  \n",
       "5                     新城中路18号  0.214075           街口  \n",
       "6                      府前路35号  0.200038           街口  \n",
       "7                     西宁中路24号  0.183469           街口  \n",
       "8                    城内路门口江路口  0.192971           街口  \n",
       "9              街口街城内路二巷2-3号首层  0.251673           街口  \n",
       "10                     街口街门口江    0.2165           街口  \n",
       "11            街口西宁西路25号(卓诗妮旁)  0.216536           街口  \n",
       "12                府前路38号-204房  0.192282           街口  \n",
       "13                     西宁中路5号  0.144074           街口  \n",
       "14                     龙江里13号  0.192971           街口  \n",
       "15                  街口街青云路34号  0.189082           街口  \n",
       "16                    西宁西路70号  0.162561           街口  \n",
       "17                     府前路79号  0.192805           街口  \n",
       "18                青云五巷街口街府前社区  0.193199           街口  \n",
       "19               新城市场侧青云路4巷2号  0.222201           街口  \n",
       "20                    中华路一巷7号  0.192971           街口  \n",
       "21         新城中路雍晟美景家园西北侧约100米  0.216536           街口  \n",
       "22  街口街中蓝东路一巷8栋104号(即JJ俱乐部背后)  0.192058           街口  \n",
       "23                     成功路51号   0.21612           街口  \n",
       "24                街口街河滨公园1号首层  0.172201           街口  \n",
       "25              中田南路四巷1幢之四、之五  0.192771           街口  \n",
       "26                 街口街蓝田西路85号  0.216561           街口  \n",
       "27                     东成路11号  0.192971           街口  \n",
       "28                 街口镇中田东路83号  0.222201           街口  \n",
       "29                   中田东路188号  0.216507           街口  "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['regeocode']['pois'])\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "861c49ab",
   "metadata": {},
   "source": [
    "### 搜索中餐厅"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "6a9f2e42",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:53:55.184864Z",
     "start_time": "2022-04-18T12:53:54.889274Z"
    }
   },
   "outputs": [],
   "source": [
    "# extension = all\n",
    "import requests\n",
    "\n",
    "regeo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\": \"ce765ab7259251e661b558e79afbe494\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"中餐厅\",\n",
    "    \"poiphotos\":\"all\",\n",
    "}\n",
    "\n",
    "r = requests.get(url=regeo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "c6528aad",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:53:55.244298Z",
     "start_time": "2022-04-18T12:53:55.226591Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "58126c0f",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:53:55.706279Z",
     "start_time": "2022-04-18T12:53:55.673266Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区街口街道新城东路99号',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '街口街道',\n",
       "   'towncode': '440117001000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '新城东路',\n",
       "    'number': '99号',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686'},\n",
       "   'businessAreas': [{'location': '113.586019,23.546975',\n",
       "     'name': '街口',\n",
       "     'id': '440117'},\n",
       "    {'location': '113.568684,23.563922', 'name': '城郊', 'id': '440117'},\n",
       "    {'location': '113.604074,23.533964', 'name': '江埔', 'id': '440117'}]},\n",
       "  'pois': [{'id': 'B0FFG2JO93',\n",
       "    'name': '柳州螺蛳粉(广百分店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '18177382828',\n",
       "    'direction': '东南',\n",
       "    'distance': '107.693',\n",
       "    'location': '113.587515,23.548360',\n",
       "    'address': '街口街道新城东路荔香村6号之三',\n",
       "    'poiweight': '0.192282',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141QWG4',\n",
       "    'name': '兴旺奶茶店',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': [],\n",
       "    'direction': '东',\n",
       "    'distance': '174.905',\n",
       "    'location': '113.588198,23.549436',\n",
       "    'address': '西宁中路西宁横街38',\n",
       "    'poiweight': '0.188565',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG6U8GM',\n",
       "    'name': '柳州螺蛳粉(街口店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '18802032191',\n",
       "    'direction': '南',\n",
       "    'distance': '254.946',\n",
       "    'location': '113.587138,23.546612',\n",
       "    'address': '开源路22号',\n",
       "    'poiweight': '0.192843',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UVY1',\n",
       "    'name': '乾坤小食坊',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13533280978',\n",
       "    'direction': '西北',\n",
       "    'distance': '223.634',\n",
       "    'location': '113.584760,23.549940',\n",
       "    'address': '街口街新村路125号',\n",
       "    'poiweight': '0.192971',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGF26NC',\n",
       "    'name': '粤饺皇(西街店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13650952135;18689436339',\n",
       "    'direction': '东北',\n",
       "    'distance': '273.444',\n",
       "    'location': '113.587903,23.551004',\n",
       "    'address': '西宁中路85号',\n",
       "    'poiweight': '0.192125',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0G17UXLBF',\n",
       "    'name': '柳州螺蛳粉',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '15920475898',\n",
       "    'direction': '东北',\n",
       "    'distance': '293.983',\n",
       "    'location': '113.589121,23.550144',\n",
       "    'address': '新城中路18号',\n",
       "    'poiweight': '0.214075',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MHS7',\n",
       "    'name': '荣记小食店(府前路店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': [],\n",
       "    'direction': '南',\n",
       "    'distance': '281.789',\n",
       "    'location': '113.587545,23.546469',\n",
       "    'address': '府前路35号',\n",
       "    'poiweight': '0.200038',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140I277',\n",
       "    'name': '西宁面店',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13926198181',\n",
       "    'direction': '东北',\n",
       "    'distance': '299.387',\n",
       "    'location': '113.589241,23.550039',\n",
       "    'address': '西宁中路24号',\n",
       "    'poiweight': '0.183469',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3URIY',\n",
       "    'name': '天天小食(城内路二巷)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '15014242018',\n",
       "    'direction': '西南',\n",
       "    'distance': '306.382',\n",
       "    'location': '113.583920,23.547614',\n",
       "    'address': '城内路门口江路口',\n",
       "    'poiweight': '0.192971',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF2N6NZ',\n",
       "    'name': '雄旺宵夜',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13533392280;13544564117',\n",
       "    'direction': '西南',\n",
       "    'distance': '331.511',\n",
       "    'location': '113.583911,23.547182',\n",
       "    'address': '街口街城内路二巷2-3号首层',\n",
       "    'poiweight': '0.251673',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0HBLUCPRK',\n",
       "    'name': '庄记美食(城内路二巷)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13711560818',\n",
       "    'direction': '西南',\n",
       "    'distance': '337.368',\n",
       "    'location': '113.583893,23.547113',\n",
       "    'address': '街口街门口江',\n",
       "    'poiweight': '0.2165',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0GK1ZXI1L',\n",
       "    'name': '168肠粉皇(新村北路)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13533398028',\n",
       "    'direction': '西北',\n",
       "    'distance': '370.995',\n",
       "    'location': '113.585246,23.551947',\n",
       "    'address': '街口西宁西路25号(卓诗妮旁)',\n",
       "    'poiweight': '0.216536',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG8Q10H',\n",
       "    'name': '527生活馆',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13535237634',\n",
       "    'direction': '南',\n",
       "    'distance': '366.316',\n",
       "    'location': '113.587848,23.545761',\n",
       "    'address': '府前路38号-204房',\n",
       "    'poiweight': '0.192282',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFH8B44L',\n",
       "    'name': '坚记联兴牛腩粉(西宁店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅|生活服务;生活服务场所;生活服务场所',\n",
       "    'tel': '13168372713',\n",
       "    'direction': '东',\n",
       "    'distance': '406.69',\n",
       "    'location': '113.590445,23.549844',\n",
       "    'address': '西宁中路5号',\n",
       "    'poiweight': '0.144074',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3V3XE',\n",
       "    'name': '朝晖美食',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '020-87900343',\n",
       "    'direction': '西北',\n",
       "    'distance': '400.835',\n",
       "    'location': '113.583449,23.551002',\n",
       "    'address': '龙江里13号',\n",
       "    'poiweight': '0.192971',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140I019',\n",
       "    'name': '天记鹧鸪饭',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '020-87937226',\n",
       "    'direction': '南',\n",
       "    'distance': '456.227',\n",
       "    'location': '113.585455,23.544887',\n",
       "    'address': '街口街青云路34号',\n",
       "    'poiweight': '0.189082',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MFCB',\n",
       "    'name': '联兴牛腩粉面(西宁西路二巷)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13556079936',\n",
       "    'direction': '西北',\n",
       "    'distance': '422.785',\n",
       "    'location': '113.584364,23.552051',\n",
       "    'address': '西宁西路70号',\n",
       "    'poiweight': '0.162561',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFH8JTAB',\n",
       "    'name': '海娃凉拌',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '020-87926536;13538906708',\n",
       "    'direction': '南',\n",
       "    'distance': '430.844',\n",
       "    'location': '113.587594,23.545085',\n",
       "    'address': '府前路79号',\n",
       "    'poiweight': '0.192805',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140V9SO',\n",
       "    'name': '四季清香美食店',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13302396325',\n",
       "    'direction': '南',\n",
       "    'distance': '431.024',\n",
       "    'location': '113.586347,23.544983',\n",
       "    'address': '青云五巷街口街府前社区',\n",
       "    'poiweight': '0.193199',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141S0WM',\n",
       "    'name': '时华煲仔饭店',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13922138248',\n",
       "    'direction': '南',\n",
       "    'distance': '456.405',\n",
       "    'location': '113.585317,23.544921',\n",
       "    'address': '新城市场侧青云路4巷2号',\n",
       "    'poiweight': '0.222201',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141RB53',\n",
       "    'name': '林记饮食店(街口村北)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13527808507',\n",
       "    'direction': '东',\n",
       "    'distance': '463.175',\n",
       "    'location': '113.591105,23.548276',\n",
       "    'address': '中华路一巷7号',\n",
       "    'poiweight': '0.192971',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0GKXADTO1',\n",
       "    'name': '文记美食(禤园东南)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '15986347323',\n",
       "    'direction': '西北',\n",
       "    'distance': '477.628',\n",
       "    'location': '113.584021,23.552435',\n",
       "    'address': '新城中路雍晟美景家园西北侧约100米',\n",
       "    'poiweight': '0.216536',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGFWW37',\n",
       "    'name': '风信子(街口店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13710622530',\n",
       "    'direction': '东南',\n",
       "    'distance': '491.088',\n",
       "    'location': '113.588766,23.544905',\n",
       "    'address': '街口街中蓝东路一巷8栋104号(即JJ俱乐部背后)',\n",
       "    'poiweight': '0.192058',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0HRGK8EE5',\n",
       "    'name': '豆花西施(成功路店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '15917475948',\n",
       "    'direction': '东南',\n",
       "    'distance': '480.747',\n",
       "    'location': '113.588470,23.544881',\n",
       "    'address': '成功路51号',\n",
       "    'poiweight': '0.21612',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141RHCA',\n",
       "    'name': '得米饭店(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '020-37939182',\n",
       "    'direction': '东',\n",
       "    'distance': '541.928',\n",
       "    'location': '113.591625,23.547248',\n",
       "    'address': '街口街河滨公园1号首层',\n",
       "    'poiweight': '0.172201',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG6VITP',\n",
       "    'name': '第壹面(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13711276057',\n",
       "    'direction': '南',\n",
       "    'distance': '558.23',\n",
       "    'location': '113.586630,23.543832',\n",
       "    'address': '中田南路四巷1幢之四、之五',\n",
       "    'poiweight': '0.192771',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0GR67ZOGW',\n",
       "    'name': '通记美食',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '15914298923;18998329882',\n",
       "    'direction': '西南',\n",
       "    'distance': '541.281',\n",
       "    'location': '113.582557,23.545702',\n",
       "    'address': '街口街蓝田西路85号',\n",
       "    'poiweight': '0.216561',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UZMQ',\n",
       "    'name': '满口香煲仔饭(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13016033133',\n",
       "    'direction': '东',\n",
       "    'distance': '574.716',\n",
       "    'location': '113.591869,23.547001',\n",
       "    'address': '东成路11号',\n",
       "    'poiweight': '0.192971',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141RDMA',\n",
       "    'name': '飘香美食店(中田东路店)',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '13688899468',\n",
       "    'direction': '南',\n",
       "    'distance': '546.881',\n",
       "    'location': '113.585497,23.544040',\n",
       "    'address': '街口镇中田东路83号',\n",
       "    'poiweight': '0.222201',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0H6FZ31N4',\n",
       "    'name': '养心园炖品',\n",
       "    'type': '餐饮服务;中餐厅;中餐厅',\n",
       "    'tel': '020-87928037;15360080006',\n",
       "    'direction': '南',\n",
       "    'distance': '570.95',\n",
       "    'location': '113.585687,23.543787',\n",
       "    'address': '中田东路188号',\n",
       "    'poiweight': '0.216507',\n",
       "    'businessarea': '街口'}],\n",
       "  'roads': [{'id': '020F49F0060454023',\n",
       "    'name': '新城东路',\n",
       "    'direction': '北',\n",
       "    'distance': '81.3964',\n",
       "    'location': '113.587,23.5481'},\n",
       "   {'id': '020F49F006045608841',\n",
       "    'name': '新城东路六巷',\n",
       "    'direction': '北',\n",
       "    'distance': '92.921',\n",
       "    'location': '113.587,23.548'},\n",
       "   {'id': '020F49F006045614615',\n",
       "    'name': '新城东七巷',\n",
       "    'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586,23.548'}],\n",
       "  'roadinters': [{'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586194,23.548025',\n",
       "    'first_id': '020F49F0060454023',\n",
       "    'first_name': '新城东路',\n",
       "    'second_id': '020F49F006045614615',\n",
       "    'second_name': '新城东七巷'}],\n",
       "  'aois': []}}"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "a85f0f5c",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:53:59.753411Z",
     "start_time": "2022-04-18T12:53:59.743922Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "51d9dd99",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-04-18T12:54:00.052436Z",
     "start_time": "2022-04-18T12:54:00.013423Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>tel</th>\n",
       "      <th>direction</th>\n",
       "      <th>distance</th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>poiweight</th>\n",
       "      <th>businessarea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B0FFG2JO93</td>\n",
       "      <td>柳州螺蛳粉(广百分店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>18177382828</td>\n",
       "      <td>东南</td>\n",
       "      <td>107.693</td>\n",
       "      <td>113.587515,23.548360</td>\n",
       "      <td>街口街道新城东路荔香村6号之三</td>\n",
       "      <td>0.192282</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B00141QWG4</td>\n",
       "      <td>兴旺奶茶店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>东</td>\n",
       "      <td>174.905</td>\n",
       "      <td>113.588198,23.549436</td>\n",
       "      <td>西宁中路西宁横街38</td>\n",
       "      <td>0.188565</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B0FFG6U8GM</td>\n",
       "      <td>柳州螺蛳粉(街口店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>18802032191</td>\n",
       "      <td>南</td>\n",
       "      <td>254.946</td>\n",
       "      <td>113.587138,23.546612</td>\n",
       "      <td>开源路22号</td>\n",
       "      <td>0.192843</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B0FFF3UVY1</td>\n",
       "      <td>乾坤小食坊</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13533280978</td>\n",
       "      <td>西北</td>\n",
       "      <td>223.634</td>\n",
       "      <td>113.584760,23.549940</td>\n",
       "      <td>街口街新村路125号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B0FFGF26NC</td>\n",
       "      <td>粤饺皇(西街店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13650952135;18689436339</td>\n",
       "      <td>东北</td>\n",
       "      <td>273.444</td>\n",
       "      <td>113.587903,23.551004</td>\n",
       "      <td>西宁中路85号</td>\n",
       "      <td>0.192125</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B0G17UXLBF</td>\n",
       "      <td>柳州螺蛳粉</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15920475898</td>\n",
       "      <td>东北</td>\n",
       "      <td>293.983</td>\n",
       "      <td>113.589121,23.550144</td>\n",
       "      <td>新城中路18号</td>\n",
       "      <td>0.214075</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B00140MHS7</td>\n",
       "      <td>荣记小食店(府前路店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>[]</td>\n",
       "      <td>南</td>\n",
       "      <td>281.789</td>\n",
       "      <td>113.587545,23.546469</td>\n",
       "      <td>府前路35号</td>\n",
       "      <td>0.200038</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B00140I277</td>\n",
       "      <td>西宁面店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13926198181</td>\n",
       "      <td>东北</td>\n",
       "      <td>299.387</td>\n",
       "      <td>113.589241,23.550039</td>\n",
       "      <td>西宁中路24号</td>\n",
       "      <td>0.183469</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B0FFF3URIY</td>\n",
       "      <td>天天小食(城内路二巷)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15014242018</td>\n",
       "      <td>西南</td>\n",
       "      <td>306.382</td>\n",
       "      <td>113.583920,23.547614</td>\n",
       "      <td>城内路门口江路口</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B0FFF2N6NZ</td>\n",
       "      <td>雄旺宵夜</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13533392280;13544564117</td>\n",
       "      <td>西南</td>\n",
       "      <td>331.511</td>\n",
       "      <td>113.583911,23.547182</td>\n",
       "      <td>街口街城内路二巷2-3号首层</td>\n",
       "      <td>0.251673</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B0HBLUCPRK</td>\n",
       "      <td>庄记美食(城内路二巷)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13711560818</td>\n",
       "      <td>西南</td>\n",
       "      <td>337.368</td>\n",
       "      <td>113.583893,23.547113</td>\n",
       "      <td>街口街门口江</td>\n",
       "      <td>0.2165</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B0GK1ZXI1L</td>\n",
       "      <td>168肠粉皇(新村北路)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13533398028</td>\n",
       "      <td>西北</td>\n",
       "      <td>370.995</td>\n",
       "      <td>113.585246,23.551947</td>\n",
       "      <td>街口西宁西路25号(卓诗妮旁)</td>\n",
       "      <td>0.216536</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B0FFG8Q10H</td>\n",
       "      <td>527生活馆</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13535237634</td>\n",
       "      <td>南</td>\n",
       "      <td>366.316</td>\n",
       "      <td>113.587848,23.545761</td>\n",
       "      <td>府前路38号-204房</td>\n",
       "      <td>0.192282</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0FFH8B44L</td>\n",
       "      <td>坚记联兴牛腩粉(西宁店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅|生活服务;生活服务场所;生活服务场所</td>\n",
       "      <td>13168372713</td>\n",
       "      <td>东</td>\n",
       "      <td>406.69</td>\n",
       "      <td>113.590445,23.549844</td>\n",
       "      <td>西宁中路5号</td>\n",
       "      <td>0.144074</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B0FFF3V3XE</td>\n",
       "      <td>朝晖美食</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87900343</td>\n",
       "      <td>西北</td>\n",
       "      <td>400.835</td>\n",
       "      <td>113.583449,23.551002</td>\n",
       "      <td>龙江里13号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B00140I019</td>\n",
       "      <td>天记鹧鸪饭</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87937226</td>\n",
       "      <td>南</td>\n",
       "      <td>456.227</td>\n",
       "      <td>113.585455,23.544887</td>\n",
       "      <td>街口街青云路34号</td>\n",
       "      <td>0.189082</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B00140MFCB</td>\n",
       "      <td>联兴牛腩粉面(西宁西路二巷)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13556079936</td>\n",
       "      <td>西北</td>\n",
       "      <td>422.785</td>\n",
       "      <td>113.584364,23.552051</td>\n",
       "      <td>西宁西路70号</td>\n",
       "      <td>0.162561</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B0FFH8JTAB</td>\n",
       "      <td>海娃凉拌</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87926536;13538906708</td>\n",
       "      <td>南</td>\n",
       "      <td>430.844</td>\n",
       "      <td>113.587594,23.545085</td>\n",
       "      <td>府前路79号</td>\n",
       "      <td>0.192805</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B00140V9SO</td>\n",
       "      <td>四季清香美食店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13302396325</td>\n",
       "      <td>南</td>\n",
       "      <td>431.024</td>\n",
       "      <td>113.586347,23.544983</td>\n",
       "      <td>青云五巷街口街府前社区</td>\n",
       "      <td>0.193199</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B00141S0WM</td>\n",
       "      <td>时华煲仔饭店</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13922138248</td>\n",
       "      <td>南</td>\n",
       "      <td>456.405</td>\n",
       "      <td>113.585317,23.544921</td>\n",
       "      <td>新城市场侧青云路4巷2号</td>\n",
       "      <td>0.222201</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B00141RB53</td>\n",
       "      <td>林记饮食店(街口村北)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13527808507</td>\n",
       "      <td>东</td>\n",
       "      <td>463.175</td>\n",
       "      <td>113.591105,23.548276</td>\n",
       "      <td>中华路一巷7号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B0GKXADTO1</td>\n",
       "      <td>文记美食(禤园东南)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15986347323</td>\n",
       "      <td>西北</td>\n",
       "      <td>477.628</td>\n",
       "      <td>113.584021,23.552435</td>\n",
       "      <td>新城中路雍晟美景家园西北侧约100米</td>\n",
       "      <td>0.216536</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B0FFGFWW37</td>\n",
       "      <td>风信子(街口店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13710622530</td>\n",
       "      <td>东南</td>\n",
       "      <td>491.088</td>\n",
       "      <td>113.588766,23.544905</td>\n",
       "      <td>街口街中蓝东路一巷8栋104号(即JJ俱乐部背后)</td>\n",
       "      <td>0.192058</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B0HRGK8EE5</td>\n",
       "      <td>豆花西施(成功路店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15917475948</td>\n",
       "      <td>东南</td>\n",
       "      <td>480.747</td>\n",
       "      <td>113.588470,23.544881</td>\n",
       "      <td>成功路51号</td>\n",
       "      <td>0.21612</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B00141RHCA</td>\n",
       "      <td>得米饭店(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-37939182</td>\n",
       "      <td>东</td>\n",
       "      <td>541.928</td>\n",
       "      <td>113.591625,23.547248</td>\n",
       "      <td>街口街河滨公园1号首层</td>\n",
       "      <td>0.172201</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B0FFG6VITP</td>\n",
       "      <td>第壹面(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13711276057</td>\n",
       "      <td>南</td>\n",
       "      <td>558.23</td>\n",
       "      <td>113.586630,23.543832</td>\n",
       "      <td>中田南路四巷1幢之四、之五</td>\n",
       "      <td>0.192771</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B0GR67ZOGW</td>\n",
       "      <td>通记美食</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>15914298923;18998329882</td>\n",
       "      <td>西南</td>\n",
       "      <td>541.281</td>\n",
       "      <td>113.582557,23.545702</td>\n",
       "      <td>街口街蓝田西路85号</td>\n",
       "      <td>0.216561</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>B0FFF3UZMQ</td>\n",
       "      <td>满口香煲仔饭(从化店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13016033133</td>\n",
       "      <td>东</td>\n",
       "      <td>574.716</td>\n",
       "      <td>113.591869,23.547001</td>\n",
       "      <td>东成路11号</td>\n",
       "      <td>0.192971</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>B00141RDMA</td>\n",
       "      <td>飘香美食店(中田东路店)</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>13688899468</td>\n",
       "      <td>南</td>\n",
       "      <td>546.881</td>\n",
       "      <td>113.585497,23.544040</td>\n",
       "      <td>街口镇中田东路83号</td>\n",
       "      <td>0.222201</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>B0H6FZ31N4</td>\n",
       "      <td>养心园炖品</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>020-87928037;15360080006</td>\n",
       "      <td>南</td>\n",
       "      <td>570.95</td>\n",
       "      <td>113.585687,23.543787</td>\n",
       "      <td>中田东路188号</td>\n",
       "      <td>0.216507</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id            name                             type  \\\n",
       "0   B0FFG2JO93     柳州螺蛳粉(广百分店)                     餐饮服务;中餐厅;中餐厅   \n",
       "1   B00141QWG4           兴旺奶茶店                     餐饮服务;中餐厅;中餐厅   \n",
       "2   B0FFG6U8GM      柳州螺蛳粉(街口店)                     餐饮服务;中餐厅;中餐厅   \n",
       "3   B0FFF3UVY1           乾坤小食坊                     餐饮服务;中餐厅;中餐厅   \n",
       "4   B0FFGF26NC        粤饺皇(西街店)                     餐饮服务;中餐厅;中餐厅   \n",
       "5   B0G17UXLBF           柳州螺蛳粉                     餐饮服务;中餐厅;中餐厅   \n",
       "6   B00140MHS7     荣记小食店(府前路店)                     餐饮服务;中餐厅;中餐厅   \n",
       "7   B00140I277            西宁面店                     餐饮服务;中餐厅;中餐厅   \n",
       "8   B0FFF3URIY     天天小食(城内路二巷)                     餐饮服务;中餐厅;中餐厅   \n",
       "9   B0FFF2N6NZ            雄旺宵夜                     餐饮服务;中餐厅;中餐厅   \n",
       "10  B0HBLUCPRK     庄记美食(城内路二巷)                     餐饮服务;中餐厅;中餐厅   \n",
       "11  B0GK1ZXI1L    168肠粉皇(新村北路)                     餐饮服务;中餐厅;中餐厅   \n",
       "12  B0FFG8Q10H          527生活馆                     餐饮服务;中餐厅;中餐厅   \n",
       "13  B0FFH8B44L    坚记联兴牛腩粉(西宁店)  餐饮服务;中餐厅;中餐厅|生活服务;生活服务场所;生活服务场所   \n",
       "14  B0FFF3V3XE            朝晖美食                     餐饮服务;中餐厅;中餐厅   \n",
       "15  B00140I019           天记鹧鸪饭                     餐饮服务;中餐厅;中餐厅   \n",
       "16  B00140MFCB  联兴牛腩粉面(西宁西路二巷)                     餐饮服务;中餐厅;中餐厅   \n",
       "17  B0FFH8JTAB            海娃凉拌                     餐饮服务;中餐厅;中餐厅   \n",
       "18  B00140V9SO         四季清香美食店                     餐饮服务;中餐厅;中餐厅   \n",
       "19  B00141S0WM          时华煲仔饭店                     餐饮服务;中餐厅;中餐厅   \n",
       "20  B00141RB53     林记饮食店(街口村北)                     餐饮服务;中餐厅;中餐厅   \n",
       "21  B0GKXADTO1      文记美食(禤园东南)                     餐饮服务;中餐厅;中餐厅   \n",
       "22  B0FFGFWW37        风信子(街口店)                     餐饮服务;中餐厅;中餐厅   \n",
       "23  B0HRGK8EE5      豆花西施(成功路店)                     餐饮服务;中餐厅;中餐厅   \n",
       "24  B00141RHCA       得米饭店(从化店)                     餐饮服务;中餐厅;中餐厅   \n",
       "25  B0FFG6VITP        第壹面(从化店)                     餐饮服务;中餐厅;中餐厅   \n",
       "26  B0GR67ZOGW            通记美食                     餐饮服务;中餐厅;中餐厅   \n",
       "27  B0FFF3UZMQ     满口香煲仔饭(从化店)                     餐饮服务;中餐厅;中餐厅   \n",
       "28  B00141RDMA    飘香美食店(中田东路店)                     餐饮服务;中餐厅;中餐厅   \n",
       "29  B0H6FZ31N4           养心园炖品                     餐饮服务;中餐厅;中餐厅   \n",
       "\n",
       "                         tel direction distance              location  \\\n",
       "0                18177382828        东南  107.693  113.587515,23.548360   \n",
       "1                         []         东  174.905  113.588198,23.549436   \n",
       "2                18802032191         南  254.946  113.587138,23.546612   \n",
       "3                13533280978        西北  223.634  113.584760,23.549940   \n",
       "4    13650952135;18689436339        东北  273.444  113.587903,23.551004   \n",
       "5                15920475898        东北  293.983  113.589121,23.550144   \n",
       "6                         []         南  281.789  113.587545,23.546469   \n",
       "7                13926198181        东北  299.387  113.589241,23.550039   \n",
       "8                15014242018        西南  306.382  113.583920,23.547614   \n",
       "9    13533392280;13544564117        西南  331.511  113.583911,23.547182   \n",
       "10               13711560818        西南  337.368  113.583893,23.547113   \n",
       "11               13533398028        西北  370.995  113.585246,23.551947   \n",
       "12               13535237634         南  366.316  113.587848,23.545761   \n",
       "13               13168372713         东   406.69  113.590445,23.549844   \n",
       "14              020-87900343        西北  400.835  113.583449,23.551002   \n",
       "15              020-87937226         南  456.227  113.585455,23.544887   \n",
       "16               13556079936        西北  422.785  113.584364,23.552051   \n",
       "17  020-87926536;13538906708         南  430.844  113.587594,23.545085   \n",
       "18               13302396325         南  431.024  113.586347,23.544983   \n",
       "19               13922138248         南  456.405  113.585317,23.544921   \n",
       "20               13527808507         东  463.175  113.591105,23.548276   \n",
       "21               15986347323        西北  477.628  113.584021,23.552435   \n",
       "22               13710622530        东南  491.088  113.588766,23.544905   \n",
       "23               15917475948        东南  480.747  113.588470,23.544881   \n",
       "24              020-37939182         东  541.928  113.591625,23.547248   \n",
       "25               13711276057         南   558.23  113.586630,23.543832   \n",
       "26   15914298923;18998329882        西南  541.281  113.582557,23.545702   \n",
       "27               13016033133         东  574.716  113.591869,23.547001   \n",
       "28               13688899468         南  546.881  113.585497,23.544040   \n",
       "29  020-87928037;15360080006         南   570.95  113.585687,23.543787   \n",
       "\n",
       "                      address poiweight businessarea  \n",
       "0             街口街道新城东路荔香村6号之三  0.192282           街口  \n",
       "1                  西宁中路西宁横街38  0.188565           街口  \n",
       "2                      开源路22号  0.192843           街口  \n",
       "3                  街口街新村路125号  0.192971           街口  \n",
       "4                     西宁中路85号  0.192125           街口  \n",
       "5                     新城中路18号  0.214075           街口  \n",
       "6                      府前路35号  0.200038           街口  \n",
       "7                     西宁中路24号  0.183469           街口  \n",
       "8                    城内路门口江路口  0.192971           街口  \n",
       "9              街口街城内路二巷2-3号首层  0.251673           街口  \n",
       "10                     街口街门口江    0.2165           街口  \n",
       "11            街口西宁西路25号(卓诗妮旁)  0.216536           街口  \n",
       "12                府前路38号-204房  0.192282           街口  \n",
       "13                     西宁中路5号  0.144074           街口  \n",
       "14                     龙江里13号  0.192971           街口  \n",
       "15                  街口街青云路34号  0.189082           街口  \n",
       "16                    西宁西路70号  0.162561           街口  \n",
       "17                     府前路79号  0.192805           街口  \n",
       "18                青云五巷街口街府前社区  0.193199           街口  \n",
       "19               新城市场侧青云路4巷2号  0.222201           街口  \n",
       "20                    中华路一巷7号  0.192971           街口  \n",
       "21         新城中路雍晟美景家园西北侧约100米  0.216536           街口  \n",
       "22  街口街中蓝东路一巷8栋104号(即JJ俱乐部背后)  0.192058           街口  \n",
       "23                     成功路51号   0.21612           街口  \n",
       "24                街口街河滨公园1号首层  0.172201           街口  \n",
       "25              中田南路四巷1幢之四、之五  0.192771           街口  \n",
       "26                 街口街蓝田西路85号  0.216561           街口  \n",
       "27                     东成路11号  0.192971           街口  \n",
       "28                 街口镇中田东路83号  0.222201           街口  \n",
       "29                   中田东路188号  0.216507           街口  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['regeocode']['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0c1133af",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4350cab8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.1"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {
    "height": "calc(100% - 180px)",
    "left": "10px",
    "top": "150px",
    "width": "384px"
   },
   "toc_section_display": true,
   "toc_window_display": true
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
